Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# O7_DICTIONARY_ACCESSIBILITY

Property | Description
--- | ---
Parameter type | Boolean
Default value | `false`
Modifiable | No
Range of values | `true | false`

`O7_DICTIONARY_ACCESSIBILITY` controls restrictions on `SYSTEM` privileges. If the parameter is set to `true`, access to objects in the `SYS` schema is allowed (Oracle7 behavior). The default setting of `false` ensures that system privileges that allow access to objects in "any schema" do not allow access to objects in the `SYS` schema.

For example, if `O7_DICTIONARY_ACCESSIBILITY` is set to `false`, then the `SELECT ANY TABLE` privilege allows access to views or tables in any schema except the `SYS` schema (data dictionary tables cannot be accessed). The system privilege `EXECUTE ANY PROCEDURE` allows access on the procedures in any schema except the `SYS` schema.

If this parameter is set to `false` and you need to access objects in the `SYS` schema, then you must be granted explicit object privileges. The following roles, which can be granted to the database administrator, also allow access to dictionary objects:

- `SELECT_CATALOG_ROLE`

- `EXECUTE_CATALOG_ROLE`

- `DELETE_CATALOG_ROLE`

  See Also: Oracle Database Upgrade Guide for more information on this parameter and the roles mentioned here Oracle Database SQL Reference for information on granting roles